How to Import table input data using CSV in uKnowva

 

  • 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

 

 

Sr

A

B

C

D

E

F

1

Username

Year

Review Cycle

Salary

Next Review Date

Output

2

Mohit.Y

2023

Annual Appraisal 2023

400000

01-04-2024

2023|Annual Appraisal 2023|400000|45383

3

Mohit.Y

2022

Annual Appraisal 2021

300000

01-04-2023

2022|Annual Appraisal 2021|300000|45017

4

Mohit.Y

2021

Annual Appraisal 2023

200000

01-04-2023

2021|Annual Appraisal 2023|200000|45017

 

 

 

 

 

 

 

 

 

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 3rd 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.

 

Was this Article helpful?