Forum Discussion

VarunAgw's avatar
VarunAgw
Copper Contributor
Jun 12, 2022

Add a column for user input in power query generated table

I have a table that is filled from a CSV file using a power query. The first column in the CSV is like a "unique identifier" or "key" for a row.

 

In the same table, I have a column named "List 1" and "List 2". These are empty by default and are supposed to be filled by the user. Now the problem is when I refresh the power query, it loads CSV again and in case CSV has a different order of row than earlier, user input of List 1 and List 2 values get assigned to the wrong row.

 

I want it to be smart. Suppose if the user assigns "List 1" = A to a row with the key "AAPL", it should remember that. When I refresh CSV, it should stick with AAPL even though the row number of AAPL has changed within the CSV.

 

 

 

2 Replies

Resources