Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
anya
Contributor III
Contributor III

Match item

hay, everybody

need a help for this care. how to take 'name' and 'date' from column f2 and make it in the form of a column

F1F2F3
Name: DST111 
Date: 12/03/2020 
   
NoProductPrice
1A50
2A50

 

thanks a lot 

7 Replies
Vegar
MVP
MVP

You should look into GENERIC LOAD.

Take a look at   Qlik Design blog post The Generic Load 

Akshada
Partner - Contributor III
Partner - Contributor III

Hi Anya,

Your question is not clear. can you please share expected output.   

anya
Contributor III
Contributor III
Author

The output that i need

NoProductPriceNameDate
1A50DST11112/03/2020
2A50DST11112/03/2020
Akshada
Partner - Contributor III
Partner - Contributor III

Hi Anya,

Try this code,

Data:
CrossTable(Name,Date,1)
LOAD
NAME,
DST111
FROM [lib://Data/Data.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1)
Where RecNo() <=1;


LOAD
"NO",
Product,
Price
FROM [lib://Data/Data.xlsx]
(ooxml, embedded labels, header is 3 lines, table is Sheet1);

 

Crosstable.PNG

Vegar
MVP
MVP

I've attached an the excel I've used for the followint script.

Data:
LOAD
  No,
  Product,
  Price
FROM
  [lib://Data/8.Import/Anya.xlsx] (ooxml, embedded labels, header is 4 lines, table is Blad1);

JOIN LOAD //Joins the Name field to all rows 
  purgechar(F2, ':') as Name  //Remove the ':'
FROM
  [lib://Data/8.Import/Anya.xlsx]  (ooxml, embedded labels, table is Blad1)
WHERE qli ='Name';

JOIN LOAD   //Joins the Date field to all rows 
  purgechar(F2, ':') as Date  //Remove the ':'
FROM
  [lib://Data/8.Import/Anya.xlsx]  (ooxml, embedded labels, table is Blad1)
WHERE qli ='Date';

anya
Contributor III
Contributor III
Author

It's work . Thank you

Vegar
MVP
MVP

Glad I could help. 😀