Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table data
Docu:LOADDocumentNo as Docu_LOW,DocumentType,Amount,DocumentDateresident test1;
Temp:LOAD num#(Docu_LOW) as Docu_LOW, num#(DocuHIGH) as DocuHIGH, Cat INLINE [Docu_LOW, DocuHIGH, DocumentCat0022108080, 0022108080, 10022102080, 0022102080, 10022106080, 0022106080, 10028300000, 0028309999, 10080910100, 0080911600, 20080912100, 0080913000, 30080990100, 0080990199, 30022108021, 0022108022, 4
];
I tired with Interval -it is multiplying records and Sync key is generating. Is their any way to avoid Syn Key.
The problem is if I have documents
0080910100 and 0080911600 - it has to update the Cat 2.
currently it is ignoring the value 0080911600 because of the join of the field Docu_LOW.
Is their any better way to join Range of values Docu_LOW , DocuHIGH into one field in the DocumentNofield in the Docu table.
Advance Thanks for your help.