Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

change the structure

Hi All,

I have a file with data like,

input data:

 

ManagerChief
NameStart DateCityJan-17Feb-17Mar-17Jan-17Feb-17Mar-17
A1/1/2017Chennai567895
Trichy4243246
Madurai567889

I need the above table as below format,

 

NameStart DateCityPositionMonthYrValue
A1/1/2017ChennaiManagerJan-175
A1/1/2017ChennaiManagerFeb-176
A1/1/2017ChennaiManagerMar-177
A1/1/2017TrichyManagerJan-174
A1/1/2017TrichyManagerFeb-1724
A1/1/2017TrichyManagerMar-173
A1/1/2017MaduraiManagerJan-175
A1/1/2017MaduraiManagerFeb-176
A1/1/2017MaduraiManagerMar-177
A1/1/2017ChennaiChiefJan-178
A1/1/2017ChennaiChiefFeb-179
A1/1/2017ChennaiChiefMar-175
A1/1/2017TrichyChiefJan-172
A1/1/2017TrichyChiefFeb-174
A1/1/2017TrichyChiefMar-176
A1/1/2017MaduraiChiefJan-178
A1/1/2017MaduraiChiefFeb-178
A1/1/2017MaduraiChiefMar-179

How can i achieve this??

Help me.

Here i attached sample excel file.

2 Replies
its_anandrjs
Champion III
Champion III

Try to load data in different table

1. First for the Manager with cross table.

2. Second with the Chief and concatenate this tables.

Anil_Babu_Samineni

The only option is this.I don't think we can work around with second ways

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful