I am trying to create a dependent column that forms a unique column. it is required to get join function to work accurately.
suppose I have a column which has 10 instance of “1000” (string), similarly it has another record “anjankum” that comes 20 times. I want to create a dependent column that should be such as -
@anjankum Read your excel file, Get all unique values from first column.
For each unique value get the count in the first column, Then use counter variable till and add the new columns till counter value is matched with count of value in First column of excel. Once columns are for one first unique, it will be repeated for other unique values.
Finally write the datatable to required excel file.