Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi evrebody , Mensuelly i Load a table i want to show the new entries for example
JULY
ID | FIRST NAME | LAST NAME | DATE OF BIRTH |
---|---|---|---|
1 | JAMES | MICKAEL | 9.06.88 |
2 | SHEPARD | LISA | 1.09.93 |
3 | LARGES | STEPHANIE | 2.09.92 |
AUGUST :
ID | FIRST NAME | LAST NAME | DATE OF BIRTH | |
---|---|---|---|---|
1 | JAMES | MICKAEL | 9.06.88 | |
2 | SHEPARD | LISA | 1.09.93 | |
3 | LARGES | STEPHANIE |
| |
4 | BEN | INESS | 31.07.90 |
So i want a result like this
NEW ENTRIES :
ID | FIRST NAME | LAST NAME | DATE OF BIRTH |
---|---|---|---|
4 | BEN | INESS | 31.07.90 |
Thank u for help
Hi,
Data:
LOAD
*
FROM AugustData;
Concatenate(AugustData)
LOAD
*,
1 AS NewRecordFlag
FROM JulyData
WHERE NotExists(ID);
Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.
Regards,
Jagan.
Jagan ,
Its doesnt work ,maybe because i have just one file with data of august and july
can you please see the attachement
Hi,
For the above logic to work you should have separate data file like one for today and one of tomorrow . You cannot use it on the same file
Regards,
@vi
Hi,
We dont have a other suggestion to resolve my problem
As you are renaming the fields, try like:
WHERE Not Exists(@1, Pivot_NumeroSecuriteSocial )
Hi,
Try like this
Data:
LOAD
*
FROM TableName
WHERE Month='July';
Concatenate(Data)
LOAD
*,
1 AS NewRecordFlag
FROM TableName
WHERE Month='August';
AND Not Exists(ID);
Now in the front end if you just want to see new records then use NewRecordFlag as filter and Select 1.
Regards,
Jagan.
i dont have any element to identify the month