I have location ID starting from location ID 1 to Location ID 7 . For X Schema I have to comment out location Id 5 to 7 , for schema Y, I have to comment Location ID5 to Location ID8 . How can we make work without commenting in all schema?
Thanks in advance
You could idendify the fields to load in a config file and load the fields to be used in first then load the data based on those fields.
It was meant that you create a new field for it either within your origin table or in a new mapping-like table, maybe in this way:
load * inline [
location ID, Group ID
I have 4 schemas to make it work and location level is till 8. Do you still think I can do this by inline load? Because script will be really long.
Right now I am trying for two schema. This is what I tried:
Load * Inline [
I will try to reload the app in both schema and check if it throws no error.
I did the data load in X schema it shows location_ID_05 field not found while debugging. Though I have already added location_ID_05 in Inline load with X schema
The inline-table was just to show the idea. If there are rather many entries it would be easier just to do it within excel and then loading this excel or copying the result again into the inline-table.