View Old Data

[John-SSI]

Hi Forum,

I got a table let's say Data
Data:
Load
ID as Ticket
Subject,
Date,
Status,
If(IsNull(Service_Lookup__c),'Not Set',SubField(SubField(SubField(Service_Lookup__c,' '),';'),'_')) as ACRON,

The field Acron is data from Database and missing some old data.
So i want to fill them with the data i got from Excel.
In the Excel i simple got Ticket and OldAcron, i have tried mappingload but i don't get it work.
Any suggestions here?

Br

I got the Old data in a Excel and want to fill the emmty ones from Excel

[igoralcantara]

Have you try ApplyMap? Here is the help file about it. See if this helps you.

ApplyMap - script function | Qlik Cloud Help

[BrunPierre]

Hi, I'd like to clarify what you mean by "missing some old data." Are you referring to null values, empty spaces, or possibly missing characters? It would be helpful if you could provide a sample of the values in the database field and the corresponding Excel sheet.

[John-SSI]

Hi,

The missing data in DB is Null
Therefore this:
If(IsNull(Service_Lookup__c),'Not Set',SubField(SubField(SubField(Service_Lookup__c,' '),';'),'_')) as ACRON,

And the Excelfile:

[BrunPierre]

Your goal is to substitute 'Not Set' with 'OldAcron' values. Hence, try

MapExcel:
Mapping LOAD Ticket,
OldAcron
FROM ... Sheet1;

Data:
LOAD *,
If(ACRON='Not Set', ApplyMap('MapExcel', Ticket),Service_Lookup__c) as ACRON1;

LOAD ...
If(IsNull(Service_Lookup__c),'Not Set',SubField(SubField(SubField(Service_Lookup__c,' '),';'),'_')) as ACRON,
...

DROP Field ACRON;
RENAME Field ACRON1 to ACRON;

[John-SSI]

Yeah, getting close here 🙂
I just wanna do something like this: (Mayby easier)
If(IsNUll(Service_Lookup__c), ApplyMap('MapExcel', ShowTheOldAcron),Service_Lookup__c) as ACRON,

[BrunPierre · Accepted solution]

If(IsNull(Service_Lookup__c), ApplyMap('MapExcel', CaseNumber), Service_Lookup__c) as ACRON

@John-SSI Read on ApplyMap - script function

[John-SSI]

Seems to work now, i was forced to texformatting CaseNumber from DB and Excel