Skip to main content
To homepage To homepage

Prepare

Ask questions about Prepare Instances in TimeXtender Data Integration

  • 233 Topics
  • 1,057 Replies
233 Topics
S
Starter
sbanerjee1Starter
asked in Prepare
Filtering on the Look up fields

Created a conditional lookup based on following : T1 joined to T2 where T1.A = T2.B Looked up T2.C based on the above join condition and stored the value in T1.D Now I need to filter the resultant data set which is on T1 based on certain values of T1.D Unable to put that filter in the Table Data Selection Rule. Even I tried to copy T1.D(look up filed) to T1.E (a separate filed created just to hold the value of T1.D) and filter on T1.E, even that did not work. Appreciate help on the same.

1214
JTreadwell
Employee
H
Contributor
hgrContributor
asked in Prepare
Conditional Lookup multiple values

I have the following set of tables: A (key1, key2) B (key2, key3) In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B. When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values? I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views? So the goal table should be like C (key1, key2, key3)

911
JTreadwell
Employee
G
Visitor
ghazyVisitor
asked in Prepare
How to RoundUp or RoundDown Decimal

Dear TimeXtender's Team,What is choice to setting rounding in TimeXtender if we want to set up decimal ? Like example .. in Original Data is $12,3456, we just want the result is $12,34 (2 decimal)because in TX, it will be $12,35Thank you,

312
JTreadwell
Employee
M
Explorer
mchinskyExplorer
asked in Prepare
Sorting a Hierarchy differently

I'm trying to create a hierarchy of GL accounts and the category they belong to. (i.e. Assets, Liabilities, Equity, Income Expenses).However the Hierarchy is displaying alphabetically.  If it were to be sorted by the first GL account it's associated with, it would sort correctly since GL accounts are numbered in the proper sequence.However, when I tell the Dimension, "Parent Category" (which is the Assets, Liabilities etc) to sort by Attribute Key, when I deploy I get an error saying it can't be used as an attribute because it is not related.Is there a workaround to this?

911
J
Contributor
J
Starter
j.romijnStarter
asked in Prepare
Table truncation options

Hi guys,Can someone elaborate the different options of table truncation? I can't really find it in the help or e-learning. We have set up an incremental load on a large table in the ODX, initially in simple mode. We found that the data after deployment & execution exists in the valid table and in the raw table, occupying twice the available storage of the original table size. We then disabled simple mode and checked the truncate raw table before transfer. I now still see some records (not all of them) in the raw table. I guess I'll have to check "Empty raw table after data cleansing" to completely empty the raw table after reloading, but I can't really grasp the difference between these options. 

3523
W
Contributor
A
Explorer
ajiExplorer
asked in Prepare
Implementing Scalar Function with COALESCE in TX

Hi TX Support,I wanna know how to implementing scalar function with COALESCE in TX ? Here I attach the function, could you please tell me how to do that?USE [QAD_DATA]GO/****** Object: UserDefinedFunction [dbo].[GetAliasesByWo1] Script Date: 03/20/2018 16:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[GetAliasesByWo1](@item nvarchar(max),@length float,@catego nvarchar(max),@opt nvarchar(max))RETURNS varchar(max)ASBEGINdeclare @output varchar(max)select @output = COALESCE(@output + ', ', '') + wo_lot + '=' + convert(nvarchar, wo_qty_ord)FROM wo_mstr_datawhere wo_part = @item andwo__dec01 = @length andwo__chr01 = @catego andRIGHT(wo_rmks,1) = @opt andwo_status = 'R' andSUBSTRING(wo_routing,1,6) = 'REWORK'return @outputEND 

255
A
Explorer
J
Contributor
jyothi.dosiContributor
asked in Prepare
Format standard measure to hh:mm format.

HI  I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.

342
J
Contributor
S
Participant
satish.padarthiParticipant
asked in Prepare
Custom Data on a table

I can see the custom data on the table when I go and check advanaced. How to know where does it exactly points to? I am trying to find the location and file name of the excel sheet I loaded.

401
JTreadwell
Employee

Badge winners

Show all badges
Terms and ConditionsCookie settings