Hello,
I have two files attached, one file is an end result import file from my workflow that has everything correct except the Asset ID. The issue is the system we are importing into has Assets IDs in which the first 8 characters will replicate what is in our new system, however in some situations these IDs will be step up assets meaning they could be the same ID but then have a ".1" or ".2" attached (making the ID 10 characters). In some situations there will be just one layer, so just a 1 for 1 but the new system needs the ID to read with the .1 at the end, but in other situations there will be this parent and then child layers too in the new system, a .1 .2 .3 and potentially so forth. There will only be the one asset in the old system but the new system could have one or several with these layered pieces attached.
I need someone to help me create a hopefully not over complicated workflow that I could use and link in with my current that essentially compare the import file to the data dump from the new system and say okay this is a situation where a record has an ID that needs to be layered, maybe it needs multiple layers in which we would have to add records to the import file and then at the end of the day add in any new records with all the same data except the needing updated Asset ID. Remember there could be situations in which based on the new system data, the import file already has the correct ID, just needs the one record updated to have a ".1" or needs the ".1" and then additional records with a ".2" and so on in the asset ID.
Another tricky part is that you will need to concatenate the company code and asset ID on both sides as there are situations where different company codes have the same asset IDs so concatenating makes it completely unique.
Thank you!
Nick
