Load an Excel tag name as a filed name

[#1]

Hi,

I have a .xlsx file whith several tags.

I am able to load each one calling each one like this:

FROM

(ooxml, embedded labels, table is SbBPP);

But I would like to load all the tags addíng a field which would be the tag name.

In the exemple above would be adding a field called Tagname = SbBPP

Give me a tip please.

Thanks

[#2]

Luis,

Not sure what you really need. But you can see my sample qvw for load each tab. Basically, each tab need have same structure.

Hope it help.

Thanks.

[brunobertels]

Hi

See my post here https://community.qlik.com/message/895596#895596

This May help you

It's using an odbc conection to get all the sheet name as a table then use this to add à dimension with the sheet name

Hope it Will help you

Bruno

[#4]

You are right, Jonathan wrote almost the fittest solution even though I did not write the question correctly.

Thank you very much Hans.