Match fct

[silviacico]

Hi all,

I have a problem with my QlikView project: I have to do a match function between a field and a variable, but it does not seem to work fine (in this way it gives as error "Field not found"

FOR i = 0 to  $(noRows) - 1
LET BU = peek('BU_file', $(i));

NoConcatenate
StagingBU:
load *,
Resident Staging
where match(BU_file, $(BU));

next i

I have also tried to do:

FOR i = 0 to  $(noRows) - 1

LET BU = FieldValue(peek('BU_file', $(i)),$(i));

load *,
'$(BU)' as Field1
Resident Staging
where match(BU_file, Field1);

next i ;

but is still not working.

Thanks!

[silviacico]

Thank you so much!

[sunny_talwar]

Not a problem

I am glad I was able to help.

Best,

Sunny

[silviacico]

Hi, I found another problem with this script:

it seems not to work with Qlik Sense, the variables take the values but the "store" does not work with variables.

It only creates a QVD "Staging_$(BU)_$(ANNO)_$(MESE).qvd"

[silviacico]

Thanks dathu for the answer, here the problem is only using Sense, because the same script works perfectly with QlikView

[sunny_talwar]

Not entirely sure with how Qlik Sense work. There might be another way of using variables in Qlik Sense and don't really have the expertise to help you with it.