5 Replies Latest reply: Jul 4, 2011 12:03 AM by BlackRockS RSS

    [Help!] How can i create a value to an existing variable and merge to another!?

      Hi everyone!

       

      I have a problem here that might be fun for you guys. I am extracting data from SAP normally, and the data from SAP contains a several columns. I am inserting another linked table too, but this table has a plus column called TYPE and it was supposed to hve the data if it is a REAL expenditure or a PROVISIONED one.

      It happens that nether the SAP have this field, nor can i remove it from the file (cus its usefull on my avaliation). Also, on the provision file, this field contains only Provision on its string value. I need to fullfill this field comming from SAP's QVD (expanditures.qvd), creating a column called TYPE with the value REAL and merge with the provisioned one. Like this one:

       

      LOAD

                Description,

                Value,

                Cost Center

      FROM Expanditures.qvd

       

      LOAD

                Name as [Description],

                Value,

                Cost Center,

                TYPE

      FROM Provision.xlsx

       

      I am new to Qlikview, can anyone help me?!

       

      Thank you very much.

      Bruno.