Can i have actual columns and unpivoted columns as part of same source

[vkomarag]

Hi,

I have a source with some columns and if i unpivot few columns actual structure will be lost. But i need to keep the actual source and in addition to the actual source, i need the unpivoted columns also.

I am thinking of creating another source and merge. Is there any better way to do this?

Thanks

KVB

[v-qiuyu-msft]

Hi @vkomarag,

If I understand it correctly, you have created a query to get data, you want to keep this source result also want to get the transformed (use unpivoted feature) data, right?

In your scenario, you can open Query Editor, duplicate the original query, then in the copy, perform the unpivoted column action. In this way, you will have two queries, the original query and transformed query.

It depends on the row data, you can merge those two queries or not. But please remember there should be a common column field between those two queries to perform Merge Queries.

Best Regards,
Qiuyun Yu

[dedelman_clng]

Can you provide a sample of your data, both how it starts out and what you hope for it to look like?

[vkomarag]

I am preparing data. My bad. Having pivoted and unpivoted data in the same source might impact the results.

Sorry.Reverting my question,