how to extract a value of a cell in the excel with tfileinputexcel

[Anonymous]

i want to extract a value in a cell, i dont want to have all the column.
Could u help me please?

[Anonymous]

Because you have to join the 3 tmap output to 3 dbOutput (which coulb be the same table)

[Anonymous]

thank u.
Now i have an other type of problem.
when i run i got this message
Starting job test at 11:54 27/03/2008.
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Warning: Usage of a local non-builtin name
Field 'ID_AUDIT' doesn't have a default valueField 'NON_CONFORMITE' doesn't have a default valueField 'ID_AUDIT' doesn't have a default valueField 'ID_AUDIT' doesn't have a default value
Job test ended at 11:54 27/03/2008.

[Anonymous]

i solve that problem but i still have other exceptions.this is what i got
Column 'DATE_AUDIT' cannot be nullColumn 'ID_AUDIT' cannot be nullColumn 'ACTIVITY_NAME' cannot be nullException in component tMap_1
java.lang.NullPointerException
at test.test.test.tFileInputExcel_1Process(test.java:667)
at test.test.test.runJobInTOS(test.java:1156)
at test.test.test.main(test.java:1075)

[Anonymous]

I think that you've checked the key checkbox or you've unchecked the null one

[Anonymous]

no.i didn't do that

[Anonymous]

this is what i did

[Anonymous]

the problem comes from your tOuputDB component, In your database you have configured your columns DATE_AUDIT,ID_AUDIT,ACTIVITY_NAME as not null, so you have to set in TOS a default value

[Anonymous]

yes these column are not nul in my database.where should i set in TOS a default value?i already do this and it did not work

[Anonymous]

have u any idea please?i need ur help

[Anonymous]

ID_AUDIT is a primary key so where can i sign a default value in TOS?can anybody help me?