Formatting Data Table

[Shan_Drex12]

Hi All,

I have 2 data table:

 The first one is a list of data that I want to transform into the format of the second, the data doesn't have the same columns as the second data. Bu

Importer Product ID	Product Description	Country Of Origin
D-1221-23	Car removal	NM
D-1221-89	Latex gloves	NM
10438509	sound system

Here is the second data table in which I want it in this format below:

ORG_CODE	PROD_DESCRIPTION	PROD_ID

Key Aspects:

ORG_CODE = Country of Origin

PROD_DESCRIPTION = Product Description

PROD_ID = Importer Product ID 

[AngelosPachis]

Hi @Shan_Drex12 ,

You can achieve what you are after by using a select tool

That tool will allow you to rename some columns and change the order they appear in your table by using the arrows at the top left hand side of your screen

[christine_assaad]

Hi @Shan_Drex12 

If I get your question correctly, you can use the "Select" building block to rename the columns, change order and get rid of any additional column you don't need. Hope this helps.

[Shan_Drex12]

Hi @AngelosPachis  & @christine_assaad 

But, I have two separate input data files, and I want the 1st data sheet to be placed in the 2nd data sheet in the corresponding columns. Wouldn't I need to  join them or use the 'fiind & replace' field. I'm not sure

[AngelosPachis]

Hi @Shan_Drex12 ,

What would be the reason for you to use the second file? Since it acts as a template and there are no values in there. I believe that with the select tool you can achieve the same output, without having to complicate things.

To demo that, I have prepared a workflow that uses that second table and also uses a join to create that table. It's quite more complicated as you can see, but it works