Question:

How to manipulate column row data into a VQL Where clause format during Veeva Align data work?

Answer:

Suppose there is the following Data Set in CSV, but there are hundreds of values, each in a row:

...

The task is to transform this data into the following format, which can be used in a VQL Where clause:

('A0435435435353','A0435435435354','A0435435435355','A0435435435356','A0435435435357','A0435435435358','A0435435435359','A0435435435350')

In Microsoft Excel, perfom the following steps:

1. Using a concatenation formula, in the next empty column, manipulate each row in the following format: 'value1',
2. Copy these values and paste them as values into an empty column.
3. In an empty row, copy the data from this column and using Special Pasting, transpose it.
4. Copy the transposed data, and paste it into Notepad or Notepad++.
5. There are blank tabs among the records. Using Find and Replace, remove the blank tabs. (Copy the tab value into Find, and do not enter any values into Replace)
6. Click Replace all.
7. Remove the comma at the end of the row.
8. Place a bracket at the beginning and the end of the row.

The data can be placed into the where clause.

Related Documentation:

Align Help Documentation: 

• Integrations and Data Loading