Forum Discussion
Table.Split( ) need to split one flat table into multiple tables
memoalkatib1 use slorin_table[Data] to get a list of tables. Table.Split gives the same structure - a list of tables and you're happy with that. What did you want to get in the end?
The grouping will give me 2 columns in the form of a list. no ? identical to this breakdown :
Value Data
S_SPONSOR_ID Table
S_ORGANIZATION Table
S_ORGTYPE Table
my question. what do I do after this step ? because I have yet to create individual tables for each row in the above example. so what would be the next stage? table. split (source, 1) ? the Data column contains individual tables and I need to step in and transform those into stand alone tables and not have it as a list as shown above
memoalkatib1 the only way to get 3 separate tables is to create 3 queries with tbl[Data]{0}, tbl[Data]{1} and tbl[Data]{2}
yeah, I was hoping that I can create a custom invoke function with and create a paramter list from 0 to approximately 500 (yes, I have that many dimension tables). and create a script and run it through the custom invoke function somehow passing through the script you mentioned above.