Forum Discussion

Prasad1's avatar
Prasad1
Helper I
8 years ago

Creating Master Data tables from Transaction data file

Hi I have a huge Sales transaction file which contains many columns from Company code to SKU code with Codes and Descriptions across multiple fields (From A to Y as showed in the attachment). I want...
Need Help
Prasad1's avatar
Prasad1
Helper I
8 years ago

Hi

 

I tried using Distinct function for creating the master table. But Distinct gives only one column with distinct values. I want the Code as well as the Description in one Master Dimension table.

 

Thanks

Prasad

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Prasad1

 

Can you provide a sample record set of say 1000 rows in excel format. Load the same in One Drive or Google Drive and share the link.

 

It is possible to do it using PowerQuery.

 

Cheers

 

CheenuSing