Using the Input Tool or any other tool

Question

Hi Friends

RegionDCCountryDec'24SamplesDefectives

This is the header of an Excel sheet. A, B & C are in row 1 whereas D & E are in row 2. If all the headers are in row 2, I can enter 2 against start date import on line but with this scenario, please let me know how can I extract the headers.

Thanks

Kallis · Answer

Hi @martinson

It is alright. I will inform the vendor to change their file.

martinson · Answer

Hi @Kallis I'm still a little confused about what manipulation you would like done to your data. Extracting headers can be done with the dynamic rename tool or using the sample tool to extract the rows with the headers. Let me know if you could clarify what you are trying to do.

Cheers,

martinson

Kallis · Answer

Hi @martinson

This is how the data looks like

CountryDec'24SamplesOthersChina1559 Japan2529 Korea20 Hong Kong77 Thailand73 Vietnam382 Taiwan262