Formatting Data Table

Question

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 IDProduct DescriptionCountry Of OriginD-1221-23Car removalNMD-1221-89Latex glovesNM10438509sound system

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

ORG_CODEPROD_DESCRIPTIONPROD_ID

Key Aspects:

ORG_CODE = Country of Origin

PROD_DESCRIPTION = Product Description

PROD_ID = Importer Product ID

AngelosPachis · Answer

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

example.yxmd

Shan_Drex12 · Answer

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

Christine_Assaad · Answer

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.