You’re offline. This is a read only version of the page.
538
Friends what is the best way to ignore the duplicate record during offline data to collection copying.
Below is my prototype,
Step 1 : Collecting data from Flow and save in to Collection A
Share
ReportIf(
Connection.Connected,
Collect(
test8,
Getpmo.Run(
LookUp(
Dailyinventoryusers,
email = User().Email,
route
)
)
);Step 2 : Saving data from Collection A to mylocaldata (Offline Database)
LoadData(
test8,
"MyLocalData",
true
);
SaveData(
test8,
"MyLocalData"
);Step 3: Saving data from mylocaldata(Offline Database) to Collection B
If(CountRows(Filter(test9,orderNumber=orderNumber)) > 0 ,
ClearCollect(
test9,
{
orderNumber: "",
orderDate: "",
customerCode: "",
equipmentCode: "",
class: ""
}
)
);
Data appearance.
Requirement is
If an identical value already exists in Collection B, the record should be disregarded while copying from Offlinedatabase to Collection B.
Identifier is Order Number
Example
OfflineData Looks like below,
Collection B Looks like below,
In this case only only below records should be collection from offline to Collection B.
Because the item beginning with 9891 is already in CollectionB, it should be disregarded.
How to Achieve this.
Please help. Thanks in Advance.
Dear experts please share your input to take this forward.
All responses (
Answers (
