Take input from two excel and formulate one
This program takes input from two excel sheet and group into one sheet DEFINE VARIABLE cal AS DECIMAL FORMAT "->>>,999,999.999". DEFINE VARIABLE cal1 AS DECIMAL FORMAT "->>>,999,999.999". /*DEFINE VARIABLE site1 LIKE sct_site.*/ DEFINE STREAM tero. DEFINE TEMP-TABLE ttinv NO-UNDO FIELD tt_part AS CHARACTER FIELD tt_qty AS DECIMAL FORMAT "->>>,999,999.999" FIELD tt_val AS DECIMAL FORMAT "->>>,999,999.999". DEFINE TEMP-TABLE ttinv1 NO-UNDO FIELD tttt_part1 AS CHARACTER FIELD tttt_qty1 AS DECIMAL FORMAT "->>>,999,999.999" FIELD tttt_val1 AS DECIMAL FORMAT "->>>,999,999.999". INPUT FROM "C:\Documents and Settings\sachingaur\My Documents\gaur-27\pptrp07.csv". REPEAT: CREATE ttinv. IMPORT DELIMITER "," ttinv. END. INPUT CLOSE. INPUT FROM "C:\Documents and Settings\sachingaur\My