Search Results

Thank you so much everyone. I am really sorry for the confusion.

The file contains only ASCII and the first 150 characters (please assume this number for the sake of understanding and to make it...

I have populated only around few records from the file as below.

Please assume first 150 characters in the line may have primary keys.

ETL01InventoryBalances SUCCESS...

Thanks for the response. But not really. There is no field separator as is. I have edited the file just for readability.

In simple terms,

How will you identify the column which can act as a primary key (or unique) in a file?

---------- Post updated at 03:28 PM ---------- Previous update was at 03:26 PM...

For Ex.

My file contains the following lines:
ETL01InventoryBalances SUCCESS
ETL02EvavivsStagingSalesOrders SUCCESS
ETL03StagevsODSSalesOrder SUCCESS
ETL04EvavivsSalesOrderHeader...

Hi,

I have a huge unsorted text file. We wanted to identify the unique field values in a line and consider those fields as a primary key for a table in upstream system.

Basically, the process...