Dynamic Schema: Loop through all fields - tJavaRow
Does anyone know a way to loop through all fields in a dynamic schema input, using the tJavaRow component? I'm trying to implement a schema validation process, however the source input data utilizes a dynamic schema, so I'm unable to utilize the tSchemaComplianceCheck component. I want to create a custom routine to determine the data type of each record in each field, however I'm not sure how to implement this routine so that it can be applied to all fields in the schema? Thanks!
I found the issue and resolved it. The code for the variable column in the tJavaFlex component was pointing to the dynamic metadata in the tFileInputDelimited component, instead I pointed to the tSetDynamicSchema component and it works. The tFileInputDelimited was setting all columns to id_String, 100 no matter the dynamic schema definition.
hi, i come on discussion because i have maybe the same problem. this my csv : id ;name 1;kpk 2; toto i use dynamic column because my csv structure can change. this is my workflow: tfileInputDelimited =>tjavaflex=>tmap=tmap; i arrive to retrieve to tjavaflex all columns from dynamic column of tfileinputdelimited. so i want to load all columns to tmap and to do transformation. but how can i do it. thank you for your help
