Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jdam0074
Contributor
Contributor

Joining Data to Existing Table Qlik Sense

I am trying to get a new column of data added to an existing table. The new column comes from an excel file that I have uploaded into the app. I basically need to append a new column that can be mapped using multiple existing columns for reference. It's based on levels of metrics for the P&L:

level 3 = top level

level 5=more detailed

level 7 =even more detailed

Basically how can I add a necessary column of new data from the excel table into the existing data table that will recognize the organizational structure for the P&L. It's a bit messy to explain this so feel free to ask follow up questions for more details. Thanks!

Labels (2)
2 Replies
abhijitnalekar
Specialist II
Specialist II

Hi @jdam0074 ,

 

Is it possible to share the structure of the tables?

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
jdam0074
Contributor
Contributor
Author

[prepPeer_Qvinci_P&L_Load]:
LOAD
%StoreNumber as PeerStoreNumber,
If(ApplyMap('Bay_Map',%StoreNumber,0)>7,'8+',ApplyMap('Bay_Map',%StoreNumber,0)) as Peer_Bay,
ApplyMap('PeerRegion',%StoreNumber,0) as Peer_Region,
ApplyMap('PeerSales',[%Period]&'-'&[%StoreNumber],0) as Peer_Sales,
ApplyMap('PeerMCO',%StoreNumber,0) as Peer_MSO,
ApplyMap('CenterAge_Map',%StoreNumber,null()) as Peer_OpenYear,
[%Period]&'-'&Level_7_Metric&'-'&Level_6_Metric&'-'&Level_5_Metric&'-'&Level_4_Metric as %PeriodPeerMetricKey,
Level_7_Value as Peer_Level_7_Value,
Level_7_Metric as Peer_Level_7_Metric,
Level_6_Metric as Peer_Level_6_Metric,
Level_5_Metric as Peer_Level_5_Metric,
Level_4_Metric as Peer_Level_4_Metric
FROM [lib://PROD - QVD Transforms/company\brand\Profitability\QvinciTransform.qvd](qvd)
Where
ApplyMap('Bay_Map',%StoreNumber,0) <> '0' and
ApplyMap('PeerRegion',%StoreNumber,0) <> '0';

Drop Tables prepPeer_Sales;

FDD_Comparison:
LOAD
Ranking,
Level_3_Metric,
Level_4_Metric,
Level_5_Metric,
Level_6_Metric,
Level_7_Metric,
Level_8_Metric,
Model_Row,
Model_%,
Model_Level,
Model_Flag,
F12,
"FDD Yr1_Row",
"FDD Yr1_%",
"FDD Yr1_Level",
"FDD Yr1_Flag",
F17,
"FDD Yr2_Row",
"FDD Yr2_%",
"FDD Yr2_Level",
"FDD Yr2_Flag"
FROM [lib://AttachedFiles/brand FDD Comparison Table.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

Hope that is what you were asking for!