Match item

[anya]

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

F1	F2	F3
Name	: DST111
Date	: 12/03/2020
No	Product	Price
1	A	50
2	A	50

thanks a lot 

[Vegar]

You should look into GENERIC LOAD.

Take a look at   Qlik Design blog post The Generic Load 

[Akshada]

Hi Anya,

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

[anya]

The output that i need

No	Product	Price	Name	Date
1	A	50	DST111	12/03/2020
2	A	50	DST111	12/03/2020

[Akshada]

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);

[Vegar]

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]

It's work . Thank you

[Vegar]

Glad I could help. 😀