Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Position Date Problem

Hello,

I have many tables, one of them has the reception date Test_Consumo_1 (Main Table) , Some codes must be changing with other dates.

I have created an excel file with code and new dates. What I want is change the date excel data into Test_Consumo_1, If not read just the field.

I attached a sample view

Thanks!

5 Replies
joshabbott
Creator III
Creator III

What is the user id?

pgalvezt
Specialist
Specialist
Author

I have deleted the credentials,

pgalvezt
Specialist
Specialist
Author

Hi,

Could you open the file?

joshabbott
Creator III
Creator III

Yes, I can.  But after looking at it, I'm not understanding exactly what you are trying to do though

pgalvezt
Specialist
Specialist
Author

I have to change the date of some codes for example:

CodigoFecha_PruebaFecha_Realfecha_precepfecha_precep1
L010-OT-00T22337CP10-08-201321-03-201221-03-201210-08-2013

10-08-2013 have to be into fecha_precep (The real value is 21-03-2013) But If(Codigo is L010-OT-00T22337CP so fecha_precep is Fecha_Prueba if not fecha_precep.

If you want delete the resident tables.