• How to Prepare Pipe separated data for importing Table Input Data

Step 1: Prepare Data as Pipe Separated format.

To Prepare the data in pipe separated format, one can use excel concat function to concat every row data pipe separated.

For ex: For above data, we can use below formula

=CONCAT(A3,"|”,B3,"|",C3,"|",D3)

By using the above formula, the output of the formula used changes to

Step 2 : To Import the Data in uKnowva

To merge the multiple cells into one, Follow below steps.

1.      Copy the output data of first row in new column(G) row. (G2)

2.      Use below formula from G3 (New column 3^rd row): =IF(A3=A4,CONCAT(G2," ",F3),F3)

3.      In the Above formula, If the username of the next row is equal, then we are trying to concat the output of Final Output of previous row (G2) with Output column F2.

If username does not match with next row username, then in that case, we are just getting the output column.

4.      The Final output for the example will be like below.

The final Step to format the new data for same user in next line can be done using below shortcut.

1.      Select Final output column and Replace Space with cltrl+J (Click cltr and J together)

2.      After above operation, the Output of the above would be 

As per the above output one needs to filter out entry with the highest  detail / where entries for an individual user and import.

Once the data is prepared one can import the data from uKnowva user master.