[resolved] how to get the column names in a data flow?

[Anonymous]

Hi ,
I'd like to know how to get the column names of a table in a flow of data: excel, delimited or postgresql.
I have to compare them to the ones I should use. It could be via a tMap component.
I must follow a strict naming plan for files and their fields...
Would you know how to get that?
Thanks,
Mathieu

[Anonymous]

Hello Mathieu
Try the code

String columnName=null;
for (java.lang.reflect.Field field: row1.getClass().getDeclaredFields()) {
      columnName=field.getName().toLowerCase();
       System.out.println(columnName);
     }

Best regards
shong

[Anonymous]

thanks shong,
It works well, I get the column names.
They're printed out in the system.
But how to export them in a delimited file?
or make a column name a data flow so that it can be compared to a reference table via a tMap component?
Thanks again ,
Mathieu

[Anonymous]

Hello

But how to export them in a delimited file?
or make a column name a data flow so that it can be compared to a reference table via a tMap component?

Define context variables to store the column name.
Best regards

shong

[Anonymous]

OK thanks

[Anonymous]

Hi,
It works correctly but I would to have access to the value or at least I would like to know if the value is null/blank. It can be a problem because I will have different type. Do you have an answer?
Thanks.

[alevy]

Use tJavaRow instead of tJava, then:
Object objValue = field.get(input_row);
String fldType = field.getType().getName();
Once you know the field type you can convert the value to the appropriate type for comparisons.

[_AnonymousUser]

plz can u tell me how to assign column names to context variable
thanks and regards
syed

[Anonymous]

plz can u tell me how to assign column names to context variable
thanks and regards
syed

[Anonymous]

plz can u tell me how to assign column names to context variable
thanks and regards
syed

Plz Give me a quick reply